Cell Referencing (Absolute and Relative Cell Referencing)

This is an example of how 'absolute' cell referencing works. Watch the three videos below to see how the spreadsheet is created.

the finished spreadsheet <<this is a pic of what the spreadsheet will look like when you are done
download the finished Excel spreadsheet <<this is the actual finished spreadsheet. You can open it in Excel and click around and see the formulas.

Video Instruction to Complete the Spreadsheet:

Step 1 - getting started (3:11)

Step 2 - using cell references rather than literal values (6:33)

Step 3 - using absolute cell references (10:49) <<note @ 7:16 note this correction: I DO want B3 to change but I don't want B11 to change